﻿CREATE TABLE [dbo].[tblMSX_configuration_environment] (
	[cfe_id] INT IDENTITY(1, 1) NOT NULL,
	[cfe_find_string] NVARCHAR(20) NOT NULL,
	[cfe_msx] BIT NOT NULL CONSTRAINT [DF_tblMSX_configuration_environment_msx] DEFAULT 0,
	[cfe_begins_with] BIT NOT NULL CONSTRAINT [DF_tblMSX_configuration_environment_begins] DEFAULT 1,
	[cfe_ends_with] BIT NOT NULL CONSTRAINT [DF_tblMSX_configuration_environment_ends] DEFAULT 0,
	[cfe_environment_name] NVARCHAR(30) NOT NULL CONSTRAINT [DF_tblMSX_configuration_environment_environment] DEFAULT 'Test',
	CONSTRAINT [PK_tblMSX_configuration_environment] PRIMARY KEY ([cfe_id])
	)
